CubePlayer Functions

MDX Functions used to create CubePlayer Functions

Best N

Equivalent to TopCount

Best in Sum

Equivalent to TopSum

Best in Percent

Equivalent to TopPercent

Worst N

Equivalent to BottomCount

Worst in Sum

Equivalent to BottomSun

Worst in Percent

Equivalent to BottomPercent

Order

Equivalent to Order

Order by Alphabet

Combination of Order function and order conditions

Order by Hierarchy

Equivalent to Hierachize

Filter

Equivalent to Filter

Remove member(s)

Combination of Filter (and NOT members …)

First N

Equivalent to Head

Last N

Equivalent to Tail

Contribution

Special sintax

For each from previous dimension

Equivalent to Generate

Without empties

Equivalent to NonEmpty

Visual Totals

Equivalent to VisualTotals

DrillDown Level

Equivalent to combination of Generate and Descendants